Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_45

R_45

ContractService

PerfContractService

Con_ContractServID

 

 

R_88

R_88

Period

NormCost

PeriodID

 

 

R_89

R_89

Service

NormCost

ServID

 

 

R_152

R_152

Service

CostServPeriod

ServID

 

 

R_230

R_230

SysFct

Action

SysFctID

 

 

R_306

R_306

CostType

Cost

CostTypeID

 

 

R_307

R_307

CostType

CostTypeText

CostTypeID

 

 

R_320

R_320

Service

Cost

ServID

 

 

R_321

R_321

ResourceItem

Cost

ResourceID

 

 

R_525

R_525

PeriodStatus

PeriodStatusText

PeriodStatusID

 

 

R_526

R_526

PeriodStatus

Period

PeriodStatusID

 

 

R_527

R_527

Period

CostServPeriod

PeriodID

 

 

R_570

R_570

EpisodeStatus

Episode

EpisodeStatID

 

 

R_582

R_582

EpisodeType

Episode

EpisodeTypeID

 

 

R_611

R_611

Service

PerfService

ServID

 

 

R_871

R_871

SysFct

Service

SysFctID

 

 

R_1121

R_1121

Episode

ContractServicesCosts

EpisodeID

 

 

R_1122

R_1122

Service

ContractServicesCosts

ServID

 

 

R_1123

R_1123

PerfService

ContractServicesCosts

PerfServiceID

 

 

R_1124

R_1124

ResourceItem

ContractServicesCosts

ResourceID

 

 

R_1125

R_1125

ContractService

ContractServicesCosts

ContractServID

 

 

R_1126

R_1126

PerfContractService

ContractServicesCosts

ContractServicePerfID

 

 

R_1132

R_1132

PerfContractService

LPerfServPerfContrServ

ContractServicePerfID

 

 

R_1133

R_1133

PerfService

LPerfServPerfContrServ

PerfServiceID

 

 

R_1486

R_1486

SysFct

LPerfContrServFormInstance

SysFctID

 

 

R_1487

R_1487

FormInstance

LPerfContrServFormInstance

FormInstanceID

 

 

R_1488

R_1488

PerfContractService

LPerfContrServFormInstance

ContractServicePerfID

 

 

R_2015

R_2015

TimePatternTimeSlot

PerfService

TimePatternTimeSlotID

 

 

R_3011

R_3011

PerfService

Images

PerfServiceID

 

 

R_8110

R_8110

OrgUnitType

CostAccount

OrgUnitTypeID

 

 

R_8111

R_8111

CostAccount

LOrgUnitCostAccount

CostAccountID

 

 

R_8114

R_8114

Period

DirectCost

PeriodID

 

 

R_8115

R_8115

CostAccount

DirectCost

CostAccountID

 

 

R_8116

R_8116

Accounts

DirectCost

AccountID

 

 

R_8117

R_8117

Service

ServicePerformance

ServID

 

 

R_8120

R_8120

Period

ServicePerformance

PeriodID

 

 

R_8121

R_8121

Period

IndirectCost

PeriodID

 

 

R_8122

R_8122

Accounts

IndirectCost

AccountID

 

 

R_8125

R_8125

CostType

IndirectCost

CostTypeID

 

 

R_8127

R_8127

CostType

IndirectCostSum

CostTypeID

 

 

R_8129

R_8129

Service

ServiceRealCost

ServID

 

 

R_8130

R_8130

Period

ServiceRealCost

PeriodID

 

 

R_8131

R_8131

CostAccount

ServiceRealCost

CostAccountID

 

 

R_8132

R_8132

Period

IndirectCostSum

PeriodID

 

 

R_8400

R_8400

PerfService

PhClininetPsChange

PerfServiceID

 

 

R_8440

R_8440

PerfContractService

PerfContractServiceDocument

ContractServicePerfID

 

 

R_8444

R_8444

PerfContractService

AccountingErrors

ContractServicePerfID

 

 

R_8670

R_8670

Episode

MandayCostData

EpisodeID

 

 

R_8671

R_8671

EpisodeType

MandayCostData

EpisodeTypeID

 

 

R_8672

R_8672

EpisodeStatus

MandayCostData

EpisodeStatID

 

 


2